package com.source.lightfowl.basedata.dao;


import com.source.lightfowl.basedata.entity.Barcode_Grant;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface BarcodeGrantDao extends JpaRepository<Barcode_Grant,String>{

    @Query(value = "select sum(grantCount) from barcode_grant where grantDate between ?1 and ?2",nativeQuery = true)
    public int getGrantCountByTime(String fromTime,String tiTime);
}
